Welcome Guest, you are in: • Login

devio dbscript ScrewTurn Wiki

Navigation¶

Main Page

Create Account

Search the wiki
»

PoweredBy

Discuss (0) View Page Code History

public outages (table)

Print

RSS

Modified on 2011/08/27 11:44 by wikibot Categorized as Uncategorized

» public outages (table)

wikibot ¶

Table

public.outages

Columns ¶

Column	Data Type	Nullable	Default	Description
outageid	integer	not null
svclosteventid	integer	null
svcregainedeventid	integer	null
nodeid	integer	not null
ipaddr	varchar(16)	not null
serviceid	integer	not null
iflostservice	timestamp with time zone	not null
ifregainedservice	timestamp with time zone	null
suppresstime	timestamp with time zone	null
suppressedby	varchar(256)	null
ifserviceid	integer	not null

Primary Key ¶

Primary Key	Columns
pk_outageid	outageid

Indexes ¶

Index	Type	Columns
outages_ifservivceid_idx		ifserviceid
outages_ipaddr_idx		ipaddr
outages_nodeid_idx		nodeid
outages_nodeid_ipaddr_svc_idx		nodeid, ipaddr, serviceid
outages_regainedservice_idx		ifregainedservice
outages_serviceid_idx		serviceid
outages_svclostid_idx		svclosteventid
outages_svcregainedid_idx		svcregainedeventid

Foreign Keys ¶

Relation	Column	Referenced Column
public.events	svclosteventid	eventid
public.events	svcregainedeventid	eventid
public.node	nodeid	nodeid
public.service	serviceid	serviceid
public.ifservices	nodeid	nodeid
public.ifservices	ifserviceid	id

Triggers ¶

Trigger	Type	Function
setifservicekeysoninserttrigger	STATEMENT AFTER	setifservicekeysoninsert
setifservicekeysonupdatetrigger	STATEMENT AFTER	setifservicekeysonupdate

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.